/*
 Navicat Premium Data Transfer

 Source Server         : sqlserver
 Source Server Type    : SQL Server
 Source Server Version : 12002000
 Source Host           : DESKTOP-I990TD3:1433
 Source Catalog        : mvcxueji
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 12002000
 File Encoding         : 65001

 Date: 15/07/2018 21:38:25
*/


-- ----------------------------
-- Table structure for __MigrationHistory
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[__MigrationHistory]') AND type IN ('U'))
	DROP TABLE [dbo].[__MigrationHistory]
GO

CREATE TABLE [dbo].[__MigrationHistory] (
  [MigrationId] nvarchar(150) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [ContextKey] nvarchar(300) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [Model] varbinary(max) NOT NULL,
  [ProductVersion] nvarchar(32) COLLATE Chinese_PRC_CI_AS NOT NULL
)
GO

ALTER TABLE [dbo].[__MigrationHistory] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [__MigrationHistory]
-- ----------------------------
INSERT INTO [dbo].[__MigrationHistory]  VALUES (N'201807030224476__first', N'vuexueji.Migrations.Configuration', 0x1F8B0800000000000400ED5D5B6FDCB8157E2FD0FF3098A7B6C87A1CA75DA486BD0B779C144693D89B7176B74F863CA2C7DAD5652A69DC318AFEB23EF427F52F949444F17ED3DD8E1120F0F0727878F8F1903C873AFCDF7FFE7BF2FD3E0A670F20CD82243E9DBF3E389CCF40BC4EFC20DE9CCE77F9DD376FE7DF7FF7DBDF9CBCF3A3FDEC475CEE0D2A076BC6D9E9FC3ECFB7C78B45B6BE0791971D44C13A4DB2E42E3F5827D1C2F393C5D1E1E19F17AF5F2F00243187B466B393CFBB380F2250FC803F9749BC06DB7CE7851F131F8459950E735605D5D9272F02D9D65B83D3790EB27CBF03BF040765D9F9EC2C0C3CC8C70A8477F39917C749EEE590CBE32F1958E569126F565B98E085D78F5B00CBDD7961062AEE8F4971DB8E1C1EA18E2C48454C6ABDCBF2247224F8FA4D2599055FBD917CE7B5E4A0ECDE4119E78FA8D785FC4EE7CBD0CB320025C6B775BC0C53544E94EE4155E7D5EC61078A8C57350A2058D0BF57B3E52ECC7729388DC12E4FBDF0D5EC6A771B06EBBF81C7EBE457109FC6BB30A43983BCC13C2601265DA5C916A4F9E3677057F17BE1CF670BB6DE82AF5857A3EA945DB988F33747F3D927D8B8771B827AE0A96EAFF224057F053148BD1CF8575E9E8334463440213AA175AEAD8FDE2F499A995BD453F93BF0D27614AE8107C1913A33F2C97B083685243882CB6497C2413F4B532FDE404D0021F3198445C9EC3ED896730D43E34652FA7D9A449F9390604E2C74B382296BC8D475622A79EDA51B90DBB35F8E8B94E732EBA66A0B30ACF27975BB9843A100EE822D63AB7C87A055B42B610E67DFD4139530C7E709CC09055C99AB5024670D67CA2527E60AEC498AC8183C5910ADA5D7651C4ADC941A57F945BB49DAAA06AAAD7AAB64DD96CC4F00FC5A8F5717C456B997E6EDC9BC8B5BF2F20164199C6A97A90F5A2E03C580A5491275219E73EF31EB6C39C1EAACFB45845733E6E5C68969244D35DB28D78271793139EB8AB2CECC9714E4AC977906C6558544B695255D997EB7F72203D335F59BBAB0C0B35046DC69A80ABA6E3420B970ED85A125CF54710DD7752933DFA4A82BE78C3A9572CF94D083C55054808CA97CBB8D0199B7AEC71C54EB652B20690BFD8F5B8347EA02321FBDFD07106FF2FBD3F91F2118823DF0F1EFAAFD2F71B086D285D24E776098D3483B8D2C3D9118B4779BCD6B933DEB0B3EDDF17974D80940858DDB1A097BF86377BBF55BB1A87470ECC60291728D33713BECD22DE60A8B86A448AB758270EB300971A597592869EB4B0652C34C7CFDA73E66E21554D33F25A9AF6BF8DB3E1A36F4F66D1F6DF2464749BBF04FAB96F50DC10372BEEBEE0C48A67D17DA81D7621A05D2483B14270227D550D478D10B92B6F895A5AD796294D5FE3A88009C11D116B77C0E6581129D295586DAD51A0AB5FB496CBDB9E8FE98ADB00CA8CFE38D66263EF33A4D4E5CE9657E0E303F9729A8E74647730576B487B9E2A657A631215D6D48C649299A9B1A4D4BCEA0E43037999A2F1354D216F210BB6EC4F88904B2ACB854D08A087299A0E16A47E65DEC3720D2F2D4DCA13993DF7BDA9A3F1BCD2BECCB769850659597992469CB743C3DEAD992499CE76DEF26F020545E5E68843A7C99C00977B8D20BF264C8DB45B7C4C12BC39EDDB1657A068915D8EB4E631DF4EA6C03DAAD3857F749DCC1BCD737F2C30F7DB7F01358DF7BB9A695375D6088B5FB3476F7F473B9A4D11D03A77B55BC62555EBC6AA458C9252B07C58A2BBD2856495B5F9FD5F92AF96703AFD314568A6E2DCADACD94F385457EDE6BEE34DACCFCB32C4BD641C1157F314172FA60BB0C0F4833076F7539868C0F1C8E255407C1162A00C81B04E29C9FE897F13908410E6667EBF2B2FAD2CBD69E2FCA1FF6CF6FC25E6D78A0D8132C1E2C977F101A876A08A4480F78E1120E2F546C419C8B3A2B88D7C1D60BED85C691B0547C481A75637CCE39D88218E92C7BD9D870C15CEA13D9A95BE506CD24B893050550036E95FE66252CCCCE6701144321D67CAF6D78BC9AC435045A4D72B1C22AB9EA3B0A52255E44150E742E4502007247601070EA6E4118274C4760540B660014AA0560D3387D21674C4D297ACF0CDA487363D55E19F5AB3035DE3EC262E534EF53492A45359C8E548AC2414532BEB66960953896ACA120B9A93C3DBC4A5C618449E24C1E06B482C4C680AD209127055C932347050C6BAF0E4107E7D31C04BFD677E907DFA65A0A7000445BCAC88613E1B3B27194B1F22328EDC9DBFA8885CD9EC31905A676C432896B288340EB2316B19B8F8254C147A94281DA6149061FFBB60781A5FAEB6EE344E908842A910C803D55E76D9A26178E47419CE0BC510DB0DA93430698F8B54D23ACA16B0F9C4EA1DC08732AE607C09C6A3C9E829A93780F54F0D0B912084088DF6F1065A70BC83094BA530B6600F0A90560D33815506500F8950E2458278735405AF1F033F2F3A244B0CF25DEE22F19A81CC659E58DE3B18088AE402E7ACB88C38AC781A003391AE2AD399196B0A13311C50E0E2567A543CB8E3779FFB0C5D440031B10A544882DD840A5B2820904AA74436DEA7EAF4081582B0C4498538D8C1277B235902B770052A9E02D9C81021DF846A041166503153CA9A5548886E5A850B34E823AD95550AA86C5C7C5BC8270F3DED67D646782A076DC9CAE3455B17FFC42C24AC8467AEA4F5025B2B3F31FCAAC78967223535F2736A3E7AF67A1C9BE7113A565F261CD2CBD58546768B5A61190C6FB6423ECE630927C6DA44491C1B7E2E65D71197037A7084559AEF63B1016B55258884B61DE7735F0772732D12E4FD1A6FAD65A70C69BFFA2F49C6CCC8DACCC545FF9C55A23445BE370DFEA5F1DB349B174BAAA7FA375935F36CDEADF6895EC5968E2ED7E51567AEB9A9D7D8DEA06D9B76904A3B48BD988B8811CC4CBB8A21CF4361F3BAB0FC53EBDFBD4484269E8E94912B22B8AA22C4CA6085B6304D5097A1FAD9187C688D05222F8D2647DE6ADF34E1665C4DF2AE164A1080D7CF2D1DB6ED1CC2435AB94D9AA8C13BCFC66E51E42372A692CD68C90F9137ADD529EA4DE0670B9487DF8E07D9066F9B9977BB71EBAD4BAF423A11873C2579C7C7053FC215E1C357C1CC235D0DF652D554C5F8929A4AAFC1E762B42C694E26EB638D862CD190AD5EC855E2AB909BE4CC25D14ABCD3AEADAC4F44CD3501BA4D594CA20BB349532C59E026513A2C9684C4508BE9C40056392306E828D8F05821D4C2C965A17B8F0269D06B83192E80740941D9926A2312F6B6891DB8D0C2DF5A547352DC1ED4C5334FAA4F574ABC0A63CC52AD98D5611DD94A75424DAD361039CD2C4D81CC751C577A28571555D96D6F7B48C77CA77B54C9DCEC42616A2F60B4061566DB804C8EBF63387CB2F55E8FA65CA74464563A97157B3CDB5EBF40644AD12C84D5D5621A86FF08E36BC94F9ACD5F8D60E04F7015657ED6784C93775340D926A4F897C24475322A943A2AEBBDD24FE908DA683D32683DBD2F0D80AB25212167855D4EB698F27B9992AD9A035DC51B5871D15398C3938906417E0D1B1C358F8D1399301A1CEECEC00C4DAF3E98E4575D5A708473AB61643954A778753195E4B06A732E7196DD6386B7B2B54B25E7477681AEAF783CF2A98146F0A91AE5C4ADCE068520C6470A2D33A8A034A714B294EB6A7554795A229D58993C15F6D936F85BCEADA853BE45415C73E298C341A9467A0D578D45758DC47445DB5A731A9021131A352A50DB92D2AC206B1FA63EF52BF080A44D72F121C4E26654C20E6585226D9D340217F6802E8B78BD9A90CE7C31A9DCAB4BECE225D1A4A479AB394F7AAD59CAD2F8CB9CF5975D5AFE73C5E47A16108E1C44135C9744EE38263932F52B78EFD98F877EDD8AC9C8AE68750052F6359643E83E279087CE4615C3D6639880E508183D53FC26518C0FE92021FBD38B883D3A20C10353F3A4451CA98D754A7F3B2E922CB7CE60CA77EDE941DAE01825C0548A8C630562DE3FC178D08D7C02F621FEC4FE7FF2A2A1DCF2E7EBEC1F55ECD0ABFCAF1EC70F6EF566F92160DB77D91D496FBBAA203FBCDDF8C7C1E481162E9D90ABBAED80A2B9403D4B1795CB155F38A87216D99E0AAB766857956B2C9D4E11E956C4242F6A464133A9207259DA055566D2D52FA294A73371A3C14F73CD440B96D2A1B881FBC141E24523E6E67A77AF46B911B7A50A4F5DB60B61387D4EC6305943B129FECD0F1B13FA5C387A27FB60CED29A7FB6DF7507BDB7A9B88C9FE2EF2F6BFA7A9B987FEED50D74A1C824F1674EAE7521C373E5D6D3BFA5060C273473E145EDED573470E20757F17E80565BDA04C7CD5A73524E8577D5AE92DD90CE8125B1A47DD930518F3A84C93D3C18A7D52A61109FE41992644B8E7643A5CB564CEB2273BDEE67D922918B7FBEB21CF4472CCD31D72D91D76A1B25A6E05A98738E4DB00571EA977379A4C4CE6D50D0BC8B93DB2D11141F64D0D29D137CE83CBEEA3CD87F1462F66F469E5737FCFE2794CF5A776A0E49E8268324BFB50441D1D231581129BBEA130EE5309425C1C6DD09C7E1F461823ECEC737FED60FC470DC6C596F2EB9589204BFD99DE54DF2618F32902075077FCF0C08008FA4A5E15984258F62A0A8E180E6D90B8EB43604AF5AD8C52154D20EC74FB3700A6802D12164F1A2BEFD9204CF311CC8441D649BCFED1C3F24F618B65FADC641A1BAD271E517FCCC0F913C0983A34CC34D035766068C7F8F7E385BB778073A7E1ED077C49E15945AF1F5FFD9030BC140BF601F3A7AE6E349F684D4FCD34883F3F66B8F9E1958DE6E39D51D5CD1422C78BE1E7F87163C36AD72345ACF0FC18969F969CCEFDDB040E7269C86F1A35DE2A68BCB44163544E69CF4A23BFBC6F659EB277D260DCAA0EEA02CF6BBA63244F2C7F027D92256B00E79A9B3084AC9711778B66AF0D662F23AF0E00CC37C19D068576B87C5963FA08BC8A70F89A60F8B2361C03E56BC3E4CBE83B07D1D786D097B530E500FBF238FA121DAC3B6DD1244CAF584C3766BEAC1F9312448F71F0A561EF6D3A6F23B4E907B8771A3999799EAAFE84C3D6371703BF5CB10184DA0B63BC50F4EA88F393D20D4345969745B09E94207A89162F090EAFEFB4BDB0C60F04DF7464F91D171B94A57D377B8CF22E0DEA3EC0883A846F17A319C0E3EE2E469F0D94BFCE41166C0889134833066BE6A05B97B988EF127CE4E638C245F8AFA340EEF9F0147C96E6C19DB7CE61F61A5D5B4773F4472FDCA1A52FBA05FE457CB9CBB7BB1C761944B7E1232D0C746ED7B55FC4A867793EB9DCA25F59175D806C06E84B8BCBF82FBB20F46BBEDF4BEED129482083407549128D658E2E4B6E1E6B4A9F84A8372A4295F86A3BC63588B62124965DC62BEF0134E1ED4B063E808DB77EC44129D444CC03C18AFDE43CF03629DCC65434487DF81362D88FF6DFFD1F8043DFA603B90000, N'6.2.0-61023')
GO

INSERT INTO [dbo].[__MigrationHistory]  VALUES (N'201807060224404__studentspassword', N'vuexueji.Migrations.Configuration', 0x1F8B0800000000000400ED5D5B6FDCB8157E2FD0FF3098A7B6C87A1CA75DA486BD0B779C144693D89B7176B74F863CA2C7DAD5652A69DC318AFEB23EF427F52F949444F17ED3DD8E1120F050E4E1E1E1C743F21CF2F07FFFF9EFC9F7FB289C3D80340B92F874FEFAE0703E03F13AF18378733ADFE577DFBC9D7FFFDD6F7F73F2CE8FF6B31F71BE37281F2C1967A7F3FB3CDF1E2F16D9FA1E445E761005EB34C992BBFC609D440BCF4F164787877F5EBC7EBD0090C41CD29ACD4E3EEFE23C8840F103FE5C26F11A6CF39D177E4C7C1066553AFCB22AA8CE3E7911C8B6DE1A9CCE7390E5FB1DF8253828F3CE676761E0413E5620BC9BCFBC384E722F875C1E7FC9C02A4F9378B3DAC2042FBC7EDC0298EFCE0B3350717F4CB2DB36E4F0083564410A6252EB5D96279123C1D76F2AC92CF8E28DE43BAF250765F70ECA387F44AD2EE4773A5F865E96012831BEAEE36598A27CA2740FAA32AF660F3B507C7855A3008205FD7B355BEEC27C9782D318ECF2D40B5FCDAE76B761B0FE1B78BC4E7E05F169BC0B439A33C81BFCC624C0A4AB34D982347FFC0CEE2A7E2FFCF96CC1965BF005EB625499B2291771FEE6683EFB042BF76E4350773CD5EC559EA4E0AF2006A99703FFCACB7390C68806284427D4CED5F5D1FB254933738D7A2A7F075EDA8EC235F020385267463E790FC1A69004477099EC52D8E96769EAC51BA80920643E83B0C899DD07DB72AC6168DC4872BF4F93E8731212CC89996E5630650D99BA4E4C39AFBD7403727BF6CB7E91F25C7EBAA9EA020CABFCB7BA5ECCA1900137C196B155BE43D02AEA9530873FDFD4039530C77F13981332B83257A148CE1AFE28979CF855604F9245C6E0C982682DBD2EE350E2A6D4B8C22FDA4D5257D5516DD55B25EBB6647E02E0D7BABFBA20B6CABD346F4FE65DDC92970F20CBE050BB4C7DD0721A283A2C4D92A80BF19C7B8F5967D3095667DD4F22BC9A314F374E4C2369AAD9465F2D18976793B3AEC8EBCC7C4941CE7AF9CDC0B82A93C8B632A72BD3EFF65E6460BAA67E5367167816F2882B0D5546D785062417AEBD30B4E499CAAEE1BACE65E69B6475E59C51A752EE991C7AB018B20A9031E56FB73020E3D6759B834ABD2C052475A1FF716D704B5D40E6A3B7FF00E24D7E7F3AFF230443B0073EFE5DD5FF250ED650BA50DAE90E0CB31B69A791A53B1283F66EB3786DB2667DC1A73B3E8F0E3B01A8B0705B23610FBFED6E377F2B26950EB6DD582052AEF1475C0F3B758B5F85494392A5D53C41B8751884B8D0CB2894D4F52503A96124BEFE531F23F10AAAE99F92D4D755FC6D1F151B5AFBB68F3A79A3A3A45EF8A755CDFA8AE00639DF75B70724C3BE0BEDC06B318D0269A41D8A1D81936A284ABCE805495DFCCCD2D63C31CA6C7F1D44008E88688B6B3E87B24089CE942A43ED6A0D85DAFD20B65E5C74BFCD565806D4FBF1462313EF799D06272EF4323E07189FCB14D463A3A3B1021BDAC35871D32BD31890AE3624E3A014CD4D8D8625675072189B4CC997012AA90B79885D1762FC400259561C2A684504B94C5077B523F32EF61B1069B96BEED09CC9AF3D6DCD9F8DC615F6653B0CA8B2C8CB4892D465DA9E1EF56CC924CEF3B6671378102A0F2F34421D3E4CE0843B5CE8057932E4EDA25BE2E09561CF6EDB323D83C40AEC75BBB10E5A75B601ED669CABFB24EE60DCEB2BF9E187BE6BF809ACEFBD5C53CB9B2E30C4DA7D1ABB7B8632D9F57388A5D15906A7F35BBC02571EF06AA4C0C9612E07058E0BBD2870495D5F9F75FB2AF96703EFD61466A46E2DD7DA459BF3C1487EDC6BCE4EDA8CFCB32C4BD641C1157F0042B2CB619B0C37623307AF78D9878CAF1DF6255407C1162A00C81B04E29C1FE897F13908410E6667EBF250FCD2CBD69E2FCA1FB6CF6FC25E6DE0A0D8132C2B2C977F102A876A08A4480F78E112762F546C419C8B3A2B88D7C1D60BED85C691B0547C481A7565FC9773B00531D259F6B2B1E182393C28B253D7CA759A4970270B0AA006DC2AFDDA4A58989DDC02288642ACF9FCDCF07835896B08B49AE462855572A47814A44ABC952A1CE85C970400E42CC220E0D49DB6300E988EC0A816CC0028540BC0A672FAE0CF989A52F4D219B491E664ACBD32EA57616ABC8A84C5CA39DFA792548A6A381DA91485838A647C7AD3C02A716059434172227A7A7895B8DC0893C4693D0C6805898D015B41224F0AB82687910A18D6DE23820ECE773A087EADCFEC0FBE4CB514E00088B694910D27C2F5B57194B1F2B29576E76DBDC5C266CFE18C0253DB6299C4359441A0F5168BD8CD4741AAE00B55A140ED18259D8F7DE883C0527D8BDC38503A02A14A2403604FD5789BAAC9C1E6511027386F541DACF6E4900E26FE73530F6BE8DA03A7532837C29C8AF90130A7EA8FA7A0E624DE03153C74AE040210E2F71B44D9E9023F0CA5EED48219007C6A01D8544E056E19007EA5030996C9610990563CFC8CFCBC2811EC7389B7F84B062A87715679E3782C20A22B908BDE32E2B0E27120E8408E86783A4FA4252CE84C44B18343C959E9D0B2E34DDE3E6C3135D0C006442911620B3650A9AC6002812ADD509A3A472C5020D60A0311665723A3C4ED6C0DE4CA1580542A780967A04007D811689049D940050F6A2915A261392AD4A893A04E76E4942A6171899957106EDEDBBA8DEC4810D48E9BD395A62AB68F9F485809D9484F7DD555223B3BFFA1CC8A67293732F47562337AFE7A169AEC2E9D282D930F6B66E9C5A21A43AB358D8034DE271B61378791E45693124506DF8A9B77C5A5C3DD9C221465B9DAEF4058D44C61212E8579DFD5C0DF9DC844BB3C459B6A5B6BC1196F1888D273B23137B232536DE5276B8D106D8DC37DAB7F756C28C5D4E9AAFE8DD64D7EDA34AB7FA355B267A189B7084459E9AD6B76F635AA1964DDA6118CD22E6623E20672100FE38A72D0DB7CECAC3E14FBF4EA532309A5A1A72749C88E288AB23099226C8D115423E875B4461E1A23424B89E04393F59EB7FE76B228230B5709270B4508E2938FDE768B46262959A5CC56653CE2E5372BF750BD514963B16684CCEFD0EB9AF224F53680FB8AD4870FDE0769969F7BB977EBA143AD4B3F12B2313B7CC5CE0757C56FE2C55EC3DB215C02FD5D9652C50E969842AAC2EF61B322644C29CE668B9D2D969CA190D05EE8A59293E0CB24DC45B1DAACA32E4D4CCF340DB5415A4DA90CE64B532953EC295036219A8CC65484E0CB0954302609FD26D8F85820D8C1C462AA75810B6FD269801B23897E0044D99169221AF3B2861639DDC8D0521F7A54D312DCCE3445A34F5A4FB70AA0CA53AC92DD68155154794A45A23D1D36902A4D8CFDE2D8ABF84CB4D0AFAAC3D2FA96967155F9A696A9D319D8C442D47E0228CCAA0DA70079D97EC6707953852E5FA64CA75734961A7735DB5CBB4EAF43D42A819CD4651582FA04EF68DD4B99CF5AF56FED4070EF6075D17E7A98DCA9A36990547B4AE4921C4D89A40E89BAEE5693F8221B4D07A74D06B7A5E1B11564A5242CF0AA28D7D31A4F723255B2406BB8A26A0F3B2A4219B37120C92EC0A36394B1F0A3BF4C06843AB3B303106BCFA73B16D5459F221CE9185E0C552ADD1D4E65182F199CCA2FCF68B1C659DB5BA192F5A2BB43D350BE1F7C5641AB78538874E652E20647AD622083139DE6511CB88A9B4A71B23DAD3A7A154DA94E9C0CFE6A9B7C2BE455C72EDC21A72A38F64E61A4DEA03C03ADFAA33EC2E2DE23EAA23DF54915F088E9952A6DC86551119E88D51F7B97F245F021BA7C91E0B03329630F31DB9232C99E060A2D441340BF5DCC4E65D820D6E854A6F5B517E97F9FD6C4E43AD2E8A7FC60AD467F7DF4CC7DF4AB8B7E3D3BFB3A9E0D4308270EAA93A6B3AF175CA47C96BAF62AA5FE5DBB482BF7A4F9E956C15F596699CFA0781E021FF92A578F590EA20394E160F58F701906B0BD24C3472F0EEEE0B028434DCD8F0E515C35E6FDD7E9BCC5BAC8329FD90DAA1F6465BB6B8070590112AA312056CB97098A4A8403E517B10FF6A7F37F15858E67173FDFE072AF668587E6787638FB77AB57548B8ADBBEA16ACB7D5DD081FDE6AF5C3E0FA40851F96C855D176C8515CA95EA583D2ED8AA7AC55396B64C70C55BB3C23C84D964E870CF603621217B04B3091DC913984ED02A8BB61629FD78A6B9190D9EB67B1E6AA05C369515C40F5E0AB724291F69B4533DFAB5C80D3D81D2FA3533DB81434AF63103CA5D924FB6EBF828A2D2EE4371445B060995D3FDB67BA8BD6DBD4CC4647F1779FBDFD3D4DC831577A86B25AEC5270B3AF5032F8E0B9FAE961D7D2830E181261F0A2FEFEA81260790BABF64F482B25E5026BE43D41A12F43B44ADF4966C0474892D8DCBEFC9028C7906A7C9EE60C53E82D38804FF044E1322DC03381DCE5A32B7DB93ED6FF33AC914D6DBFDBD93672239E6B111B9EC0EBB50592D9782D4D321F265802B8FD44B214D0626F34E8805E4DC9E05E98820FB0A8894E81BE7CE65D7D1E6CD7893373E2CF6248D9EF4E8D378E8FEE0C6F3D0204F6D9FCABD55D164F0F7A1DF3ADA9D2A2239367DE461DCB71C84C03DDAA83EFDBEDC30465CDCE7FE1CC3F8AF2E8C8B2DE5F59A89204B7D8F70AA8F278CF9568203A83B7E196140047D25CF1E4C216E7C15A6478CD7364860F82130A5BACCA3544513888BDDFE918229608BC4ED9306F37B3608D3DCD29930C83A795060F47703A6B0C432DD8799C642EB8987FC1F33B2FF0430A68E5D330D748D1DB9DA3140FF78F1F81DE0DC69FCFD019F7A7856E1F5C7573F244E30C5827D44FFA9AB1BCD1DB2E9A9990601F2C78C873FBCB2D1DC091A55DD4C21B4BD181F8FEF3736EE77DD53C40ACFF7617963E574EEDF26B0934B437ED3B0F65651EDA5151AC3864A5B561AF9E56D2BBF295B278D16AE6AA02E32BEA63946F2C4F227D0279F6415E0AFE62A0C31F565C4DDC2ED6BA3EDCBC8AB2314F35570BB41A11EEEBBAC327D886045BC7E4DB47E591D8E91FCB571FC65F49DA3FC6B63FCCB6A98F20B00F240FF121DACDB6DD1244CCF6C4C37A8BFAC1D9312448F81FAA571F96D1A6F23B4E947E077EA3999799E2AFE84E3EA3717033F5DB1118EDA0B63BC58F9EA90F893D20D4385BE9785D89E94207A09672F895EAF6FB4BDB0C68F54DFB467F915171B35A67D337B0C432F8D3A3F408F3AC497178324C0EDEE2E46B711CA5FE7200B3684C409A4198335B3D1ADF35CC47709DE72731CE12CFCA52B907B3EDC059FA57970E7AD73F8798D4EC3A331FAA317EED0D417DD02FF22BEDCE5DB5D0E9B0CA2DBF0911606DAB7EBEA2F82E8B33C9F5C6ED1AFAC8B264036037481E332FECB2E08FD9AEFF79273740A12C820501D92447D99A3C3929BC79AD227212C8F8A5025BEDA8E710DA26D08896597F1CA7B004D78FB92810F60E3AD1F71AC0B35117347B0623F390FBC4D0A9731150D521EFE8418F6A3FD77FF07BCC86B350CBA0000, N'6.2.0-61023')
GO

INSERT INTO [dbo].[__MigrationHistory]  VALUES (N'201807060246069__teacherstelephone', N'vuexueji.Migrations.Configuration', 0x1F8B0800000000000400ED5DDB6E1CB9117D0F907F18CC53127835929D2C1C41DA8532B20321B6A5F5C8BB9B27819AA646BDDB9749778F3242902FCB433E29BF10B26FBCDFFA2E59306068D864B1583CAC26ABD855FFFBCF7F4FBEDF87C1EC0126A91F47A7F3A383C3F90C46EBD8F3A3CDE97C97DD7DF376FEFD77BFFDCDC93B2FDCCF7EACEABDC1F550CB283D9DDF67D9F678B148D7F73004E941E8AF93388DEFB283751C2E80172F5E1F1EFE797174B48088C41CD19ACD4E3EEFA2CC0F61FE03FD5CC6D11A6EB31D083EC61E0CD2B21C3D59E554679F4008D32D58C3D37906D36CBF83BFF80745DDF9EC2CF001E2630583BBF90C44519C810C7179FC2585AB2C89A3CD6A8B0A4070FDB885A8DE1D085258727F4CAADB0EE4F0351EC88234AC48AD776916878E048FDE949259F0CD1BC9775E4B0EC9EE1D9271F688479DCBEF74BE0C409A422431BEAFE36590E07AA2740FCA36AF660F3B983F7855A3008105FF7B355BEE826C97C0D308EEB20404AF6657BBDBC05FFF0D3E5EC7BFC2E834DA0501CD19E20D3D630A50D155126F61923D7E867725BF17DE7CB660DB2DF8867533AA4D31948B287BF37A3EFB843A07B701AC279E1AF62A8B13F85718C10464D0BB0259069308D380B9E884DEB9BE3E825FE22435F7A8A7F27708927614AE2140E0489C19F9041EFC4D2E098EE032DE2568D2CF9204441BA40910643EC320AF99DEFBDB62AD55D0B891D47E9FC4E1E7382098132BDDAC50C91A31751D9B6A5E836403337BF68B7991F25C3CBA29FB820CABFCB3BADF8A43A14235045BC656D90E432BEF57C25CF5F8A65EA88439FE99C09C50C195B9124572D6AA8772C9894F05F62455640C9E2C88D6D2EB320E256E4A8D6BFCA2DD247D9513D556BD95B26E4BE627087FADE7AB0B62AB0C24597B32EFA296BC7C80698A96DA65E2C196AF817CC292380EBB10CF39784C3B7B9D54EAACFB9708AF66CCAF1B27A6B134D56CE3A7168CCBABC95957D47566BEA02067BD7866605C5549645B59D395E9777B101A98AEA9DFD495059E853AE24E4355D175A381C8056B1004963C53D5355CD7B5CC7C93AAAE9C33EA54CA3D53430F1643550132A6FAED360664DDBA1E7370AB97AD80A42FFC7FD51B3A52E790F908F61F60B4C9EE4FE77F4460F0F7D0AB7E97FD7F89FC35922E9276B283C39C46DA6964E989C4A0BDDB6C5E9BEC595FF0E98ECFD7879D0054D8B8ADB1B0873F76B77B7F2B5E2A1D1CBB2B8148B9AE1E56FDB0AF6EF1A9F0D2905469F59E20DC3A2CC2AAD1CB2A94F4F525858961251EFDA98F957885D4F44F71E2E93AFEB68F8E0DA37DDB479FD73080DBFB38D28AF9A88F9E7973A7A463F4A755CFFA8ED0D13CDB7577FA240AA70BBDC4EB4F8DEA6AA497F2B3889352CA5BBC6824495FFC3BADAD6164947DC6B51F42B422C26DD5F33992052E74A6549A88576B24D4EE17B1F5B6A6FB03BEC226A1B604345A99D569DB6971568D5ED6E700EB7399C07A6D74B456D0407B582B6E7A651A0BD2D57A655C94A2A1ABD1B2E44C590E6B9369F9B240257D61DFB4EB468C5F48304DF3EB0CAD8860670D9EAE7664DE455E03222DCFEB1D1A52F9BDA7ADE1B5D1BAAABCE80E0BAA68F2B292247D990EC6AF7BB6A112B77DDB5B113C0895D7261AA1AEBAC6E084BBAAD10BF264C8DB85B7C4B52CC39EDDB1657AA69015DCEB4E631D8CEA6C03DBBD71AE4C969A2EB8FCE187BE7BF809AEEF41A6E9E54D171862ED3E8D1D4D43190BFBB93ED3E81685D3CD315E812BAF963552E0E41A998302AF1ABD2870495F5F9F5DFD2AFE6703BFDA640CE5A3BC0BBBB5996BB78BCE9741798DA3B92F6AA373CED2345EFB3957FCA50FC9F98A1D323A02CE1C6E021473C8DC2F4073891491BF45AA07F1863034E755CC65748EB097C1D9D9BAF8106009D235F044F9A3F1794DD8AB4D2B147B824D87E5F20F42E74801C2046B20102CD1F42295EA4799A82DFD68ED6F41602F348E84A5CAC5D2A83BE39F9CC32D8CB0B6B4978D0D17CC8549919DBA576ED24C823B59500035E056E9CB57C2C2ECD81740311462CD770687C7AB495C43A0D524172BAC926BD4A32055E22755E140E734250020F72F0601A7EE868971C1740446B5600640A15A00369DD3979DC6D494A27FD0A08D34B781ED9551BF0A53E3CF242C96D702FA54924A510DA72395A27050918C37711A5825AE336B28486E814F0FAF12671F6192B8CB8701AD20B131602B48E44901D7E4AA5201C3DA6F45D0C1796D07C1AFF5770A836F532D053800A22D6564C389F0C9DE38CA58F98199F6E46D7DC4AA0CAEC31905A676C432896B288340EB2316B1D88F8254C10BAB4281DA254B26BFF2DE0F024BF597F3C685D21108552219007BAAC1DB744DAE548F8238C16DA49A60B50F894C30F1DC9B665843D71E389D42B911E654CC0F8039D57C3C053527F11EA8E0A173251080108FE320CA4E17EC622875A716CC00E0530BC0A6732A58CD00F02B1C48A84D865AC0A4E4E167EC61C685709F49FCD45F5258BAAAD3D21BC76301135DC14CF4961187158F0341077234C47B81222D614367225A3938949C150E2D3BDEE4E3AB2CA6061A9501514A84D8820D544A2B9840A02C37B4A66E300B1488B5C2408439D5C82871275B03B9620720954AB5853350A0830A0934C84BD940A55AD4522A44C37254A85527419DECB22BD5C2E2C36D5E41B8796FEB31B22B41503B6E4E579AAA383EFE45C24AC8467AEACF7B25B2B3F31FCAAC789672234B5F2736A3E7AF67A1C9BEE213A565F261CD2CBD58D46068B5A61190C6FB6423ECE630927C4FA54491C1B7E2E65D71997037A7084559AEF63B1016F5A6B01097C2BCEF6AE0EF4E64A25D9EA24D8DADB5E08CDF3688D273B23137B2325363E55FD61A21DA1A87FB56FFEA78588A57A7ABFA375A37F9D7A659FD1BAD923D0B4DFC7E419495DEBA66675FA38641F66D1AC128ED6236226E2007F11AB02807BDCDC7CEEA43B14FEF3E3592501A7A7A9284EC8AA2280B9329C2D618410D82DE476BE4A13122B494487569B23EF3D6CF4E164534E5B2E064A108BB7CF2116CB77865929665C96C55C4605E7EB3720F4F1C1634166B46C8FC09BDEE298B13B081DC53AC3E3CF8DE4FD2EC1C64E016E04BAD4B2F14AA31277CC5C9A7EA8A3FC48BB3561D87AA16F8EFA2952A5EB2C41452367E8F861562634A7E2B5C9C6CB1E50C87C10601482477D09771B00B23B55947DD9A989E691A6A83B49A5211C098A65294D853A06C4234198DA908C39713A8604C12E64DB0F1B140B08389C5ABD6052EBC49A7016E8C24FA01106547A68968CCCB1A5AE47623434B7DE9514D4B703BD3148D3E693DDD32682C4FB12C76A395478EE529E585F674D8E0B13431F689E3AC5677A28579555D96D68FB48825CB0FB5289DCEC22616A2F62F80DCACDAF015206FDBCF1A2EBE54A1DB1725D399158DA5C65DCD36D7AED39B10B54A2037755985A0BEC13BDAF452E6B356F35B3B10DC2758DDB49F19265FF3D13448A93D25F2791E4D89940E893AEA633B760757178FB133AD3E8AA3E954659359038511B315FCA5242CB0AF68D7D37E5172CB55B2D96BB83BEB00C224CE1A036152EC023C3AD21A0B3FFAC96440A833613B00B1F6A2BA6351DDF429C2918E44C650A5CADDE154042393C1A978F28C367E9CE5BE152A598FBC3B340DEDFBC167197A8B37AB48DF5C4ADC54B1B718C854854EEFD12AFC16F72AAD8AED69D531B8684A75E164F057DBF75B21AFBCC2E10E3955C3B14F1D23CD06E56568351FF57518F7195137ED694ECAB04DCCAC9465436E8BF2204BACFED8BBB4CF4328D1EDF30287538E78AAB8723D51E000493401FCDBC58455043F620D5845595F6791FECF7C4DCCB723AD7ECAA7D66AF5D7D7D8DC57BFBAE9D76325A8A3F23084AAC2716C051DE8B7E9D80804D72D5FA5EEBD2CA97FD7AEDBD26D6A4EA32BF8518B2AF31912CF83EF611FEAEA31CD6078802B1CACFE112C031F8D9754F80822FF0E2DB122F8D6FCF5218E34C7E4E29D4E5EDC459A7ACCC9529D1C979DAE010288F958A8C610612D7335E49D0817DD2F220FEE4FE7FFCA1B1DCF2E7EBEA9DABD9AE59EA3E3D9E1ECDFAD32DAE61DB7CD676BCB7DDDD081FDE619479F0752843885B6C2AE1BB6C20AE5E275ECBE6AD8AA7B455A515B26B8E6AD5961929236593A5C4AD226246409499BD091A423758256D1B4B548E944A6E661344833F83CD440B16D2A3A881E40828E37091F7BB5533DFAB5C80D2785699D59CE76E190967DBC01E5AED2273B757C5C55E9F4E1C8AA2DC3A6CAE97EDB3DD4DEB68F912AE7F5A8F5FEB3A2FBBB10EC7F4F53738F0BDDA11297F83F9F2C9AD5B9741C77545DED67FAD08C422E2C0F092FEB2A17960348DD9346BDA0AC179489299F5A43824EF9D44A6FC9564097D8D2F8259F2CC0988C434D8E1D2B36DF5023127CB6A12644B85C431DBEB564BEC1273BDFE60D98298EB97B6A9967223926AF8B5C76875DA8AC967B4C2A4B8B7C1BE0CA239594A5C9C2BC32EF779D592219583A22C8265C91127DE33CB9EC3EDA7CCA6F924EC5E2B0D3287B4A9F5649F7DC26CF43833CB503309716A4996BA1A7036F1F8AB3A363AF222666D37419E366C510422069E323F59B03638C08C3CF3DB1C5F8F92BC6C596F243A589204BFD45E654D3508C9975C201D41DE7981810415F4902892944E02F031E8991EF0609B13F04A6549F322955D104228CB74FF730056C910888142F0327711802619A6F94260CB24E52338C9E81610A5B2CD3D740D3D8683DF1E40963E6489800C6D45180A681AEB163803BA63A182FB381039C3BCD643060D28C6795A8607CF543222E532CD8E74698BABAD17C41373D35D320D5C09899058657369A2FA246553753481220461AE4E78D8DA05ECF14B1C2F373587C63733AF76E6334C98521BF698200ABFC00D20E8D0158A5232B8CFCF2B115CF94A393C65D570D50976340331C237962F913E89347B20EAAA7E62E0CD90964C4DD121768F316C8C8AB633DF35D70A741A11FEEB9AC337DB06545E6034DDE03591F8E3911B4191164F49DF32568B325C87A98722E0579CA04890ED69DB66812A68425D34D8F201BC7A404D163CA036986039BC1DB086DFAB90C9C664E669EA79A3FE10C05CDC5C0BFAED8F84EED85315ED60175728149E986A19208C882954F4A10BD240690E401D00FDA5E58E3C7FC6F3AB3FC8E8B8D99D37E983D06F497C6EF1F60461D22F58B611DD0717717E1CF1C8A5FE730F53784C409A219C13573D0ADEB5C44777175E4E638AAAAF05F73C10C78E8147C9664FE1D5867E8F11A5FB3C76BF44710ECF0AB2FBC85DE4574B9CBB6BB0C0D1986B7C1232D0C7C6ED7F59FA72360793EB9DCE25F691743406CFAF8CB90CBE82F3B3FF06ABEDF4BEED1294860834079FB12CF65866F616E1E6B4A9F84D0252A42A5F86A3BC6350CB70122965E462BF0009BF0F625851FE006AC1FABE81C6A22E68960C57E72EE834D82B631250DD21EFD4418F6C2FD77FF07E9FE901F4ABC0000, N'6.2.0-61023')
GO


-- ----------------------------
-- Table structure for Classes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Classes]') AND type IN ('U'))
	DROP TABLE [dbo].[Classes]
GO

CREATE TABLE [dbo].[Classes] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [MajorsId] int NOT NULL,
  [Year] int NOT NULL,
  [TeacherId] int NOT NULL
)
GO

ALTER TABLE [dbo].[Classes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Classes]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Classes] ON
GO

INSERT INTO [dbo].[Classes] ([Id], [MajorsId], [Year], [TeacherId]) VALUES (N'2', N'1', N'2017', N'1')
GO

INSERT INTO [dbo].[Classes] ([Id], [MajorsId], [Year], [TeacherId]) VALUES (N'3', N'2', N'2017', N'1')
GO

INSERT INTO [dbo].[Classes] ([Id], [MajorsId], [Year], [TeacherId]) VALUES (N'4', N'3', N'2017', N'1')
GO

SET IDENTITY_INSERT [dbo].[Classes] OFF
GO


-- ----------------------------
-- Table structure for Classrooms
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Classrooms]') AND type IN ('U'))
	DROP TABLE [dbo].[Classrooms]
GO

CREATE TABLE [dbo].[Classrooms] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [Name] nvarchar(4) COLLATE Chinese_PRC_CI_AS NOT NULL
)
GO

ALTER TABLE [dbo].[Classrooms] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Classrooms]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Classrooms] ON
GO

INSERT INTO [dbo].[Classrooms] ([Id], [Name]) VALUES (N'1', N'510')
GO

INSERT INTO [dbo].[Classrooms] ([Id], [Name]) VALUES (N'2', N'508')
GO

INSERT INTO [dbo].[Classrooms] ([Id], [Name]) VALUES (N'3', N'507')
GO

INSERT INTO [dbo].[Classrooms] ([Id], [Name]) VALUES (N'4', N'506')
GO

INSERT INTO [dbo].[Classrooms] ([Id], [Name]) VALUES (N'5', N'511')
GO

INSERT INTO [dbo].[Classrooms] ([Id], [Name]) VALUES (N'6', N'509')
GO

SET IDENTITY_INSERT [dbo].[Classrooms] OFF
GO


-- ----------------------------
-- Table structure for Courses
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Courses]') AND type IN ('U'))
	DROP TABLE [dbo].[Courses]
GO

CREATE TABLE [dbo].[Courses] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [Name] nvarchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [LecturerId] int NOT NULL
)
GO

ALTER TABLE [dbo].[Courses] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Courses]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Courses] ON
GO

INSERT INTO [dbo].[Courses] ([Id], [Name], [LecturerId]) VALUES (N'1', N'PHP', N'1')
GO

INSERT INTO [dbo].[Courses] ([Id], [Name], [LecturerId]) VALUES (N'2', N'视觉元素', N'2')
GO

INSERT INTO [dbo].[Courses] ([Id], [Name], [LecturerId]) VALUES (N'3', N'开发模式', N'1')
GO

INSERT INTO [dbo].[Courses] ([Id], [Name], [LecturerId]) VALUES (N'1002', N'高数', N'1002')
GO

SET IDENTITY_INSERT [dbo].[Courses] OFF
GO


-- ----------------------------
-- Table structure for CoursesArrangings
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[CoursesArrangings]') AND type IN ('U'))
	DROP TABLE [dbo].[CoursesArrangings]
GO

CREATE TABLE [dbo].[CoursesArrangings] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [ClassesId] int NOT NULL,
  [CoursesId] int NOT NULL,
  [WeekArrangingId] int NOT NULL,
  [WeekStart] int NOT NULL,
  [WeekEnd] int NOT NULL,
  [LessonsOrder] int NOT NULL,
  [ClassroomId] int NOT NULL,
  [WeekDays] int NOT NULL
)
GO

ALTER TABLE [dbo].[CoursesArrangings] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [CoursesArrangings]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[CoursesArrangings] ON
GO

INSERT INTO [dbo].[CoursesArrangings] ([Id], [ClassesId], [CoursesId], [WeekArrangingId], [WeekStart], [WeekEnd], [LessonsOrder], [ClassroomId], [WeekDays]) VALUES (N'1', N'2', N'1', N'1', N'1', N'18', N'1', N'1', N'1')
GO

INSERT INTO [dbo].[CoursesArrangings] ([Id], [ClassesId], [CoursesId], [WeekArrangingId], [WeekStart], [WeekEnd], [LessonsOrder], [ClassroomId], [WeekDays]) VALUES (N'2', N'3', N'1', N'1', N'18', N'3', N'4', N'1', N'1')
GO

INSERT INTO [dbo].[CoursesArrangings] ([Id], [ClassesId], [CoursesId], [WeekArrangingId], [WeekStart], [WeekEnd], [LessonsOrder], [ClassroomId], [WeekDays]) VALUES (N'3', N'2', N'1', N'1', N'18', N'1', N'5', N'1', N'1')
GO

INSERT INTO [dbo].[CoursesArrangings] ([Id], [ClassesId], [CoursesId], [WeekArrangingId], [WeekStart], [WeekEnd], [LessonsOrder], [ClassroomId], [WeekDays]) VALUES (N'4', N'2', N'1', N'1', N'1', N'18', N'5', N'2', N'2')
GO

INSERT INTO [dbo].[CoursesArrangings] ([Id], [ClassesId], [CoursesId], [WeekArrangingId], [WeekStart], [WeekEnd], [LessonsOrder], [ClassroomId], [WeekDays]) VALUES (N'5', N'2', N'1', N'1', N'1', N'18', N'1', N'1', N'4')
GO

INSERT INTO [dbo].[CoursesArrangings] ([Id], [ClassesId], [CoursesId], [WeekArrangingId], [WeekStart], [WeekEnd], [LessonsOrder], [ClassroomId], [WeekDays]) VALUES (N'6', N'2', N'1', N'1', N'1', N'18', N'2', N'3', N'4')
GO

INSERT INTO [dbo].[CoursesArrangings] ([Id], [ClassesId], [CoursesId], [WeekArrangingId], [WeekStart], [WeekEnd], [LessonsOrder], [ClassroomId], [WeekDays]) VALUES (N'7', N'2', N'1002', N'1', N'1', N'18', N'1', N'3', N'5')
GO

INSERT INTO [dbo].[CoursesArrangings] ([Id], [ClassesId], [CoursesId], [WeekArrangingId], [WeekStart], [WeekEnd], [LessonsOrder], [ClassroomId], [WeekDays]) VALUES (N'8', N'2', N'3', N'1', N'1', N'12', N'2', N'3', N'5')
GO

INSERT INTO [dbo].[CoursesArrangings] ([Id], [ClassesId], [CoursesId], [WeekArrangingId], [WeekStart], [WeekEnd], [LessonsOrder], [ClassroomId], [WeekDays]) VALUES (N'9', N'3', N'2', N'1', N'1', N'18', N'1', N'6', N'1')
GO

SET IDENTITY_INSERT [dbo].[CoursesArrangings] OFF
GO


-- ----------------------------
-- Table structure for Exams
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Exams]') AND type IN ('U'))
	DROP TABLE [dbo].[Exams]
GO

CREATE TABLE [dbo].[Exams] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [CoursesArrangingId] int NOT NULL,
  [Name] nvarchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [TimeStamp] datetime NOT NULL,
  [StudentScore] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[Exams] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Exams]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Exams] ON
GO

INSERT INTO [dbo].[Exams] ([Id], [CoursesArrangingId], [Name], [TimeStamp], [StudentScore]) VALUES (N'1', N'1', N'13', N'2018-07-15 21:02:51.000', N'[{"StudentsId":"3","Score":"12"},{"StudentsId":"7","Score":"12"}]')
GO

SET IDENTITY_INSERT [dbo].[Exams] OFF
GO


-- ----------------------------
-- Table structure for Lecturers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Lecturers]') AND type IN ('U'))
	DROP TABLE [dbo].[Lecturers]
GO

CREATE TABLE [dbo].[Lecturers] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [UserName] nvarchar(15) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [PassWord] nvarchar(16) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [Name] nvarchar(8) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [MajorsId] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
  [Status] int NOT NULL,
  [Telephone] nvarchar(11) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL
)
GO

ALTER TABLE [dbo].[Lecturers] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Lecturers]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Lecturers] ON
GO

INSERT INTO [dbo].[Lecturers] ([Id], [UserName], [PassWord], [Name], [MajorsId], [Status], [Telephone]) VALUES (N'1', N'zhuangdexin', N'123456789', N'庄德鑫', N'1', N'1', N'12345678998')
GO

INSERT INTO [dbo].[Lecturers] ([Id], [UserName], [PassWord], [Name], [MajorsId], [Status], [Telephone]) VALUES (N'2', N'lixiaohang', N'123456789', N'李笑航', N'2', N'1', N'12345678998')
GO

INSERT INTO [dbo].[Lecturers] ([Id], [UserName], [PassWord], [Name], [MajorsId], [Status], [Telephone]) VALUES (N'1002', N'zhangmin', N'123456789', N'张敏', N'0', N'1', N'12345678998')
GO

SET IDENTITY_INSERT [dbo].[Lecturers] OFF
GO


-- ----------------------------
-- Table structure for Majors
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Majors]') AND type IN ('U'))
	DROP TABLE [dbo].[Majors]
GO

CREATE TABLE [dbo].[Majors] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [Name] nvarchar(12) COLLATE Chinese_PRC_CI_AS NOT NULL
)
GO

ALTER TABLE [dbo].[Majors] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Majors]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Majors] ON
GO

INSERT INTO [dbo].[Majors] ([Id], [Name]) VALUES (N'1', N'软件')
GO

INSERT INTO [dbo].[Majors] ([Id], [Name]) VALUES (N'2', N'UI')
GO

INSERT INTO [dbo].[Majors] ([Id], [Name]) VALUES (N'3', N'会计')
GO

SET IDENTITY_INSERT [dbo].[Majors] OFF
GO


-- ----------------------------
-- Table structure for Rollcalls
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Rollcalls]') AND type IN ('U'))
	DROP TABLE [dbo].[Rollcalls]
GO

CREATE TABLE [dbo].[Rollcalls] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [CoursesArrangingId] int NOT NULL,
  [CreateTime] datetime NOT NULL,
  [StudentState] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
  [Name] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[Rollcalls] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Rollcalls]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Rollcalls] ON
GO

INSERT INTO [dbo].[Rollcalls] ([Id], [CoursesArrangingId], [CreateTime], [StudentState], [Name]) VALUES (N'1', N'5', N'2018-07-15 19:53:11.667', N'[{"StudentsId":"3","State":"0"},{"StudentsId":"7","State":"1"}]', N'庄德鑫')
GO

SET IDENTITY_INSERT [dbo].[Rollcalls] OFF
GO


-- ----------------------------
-- Table structure for Students
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Students]') AND type IN ('U'))
	DROP TABLE [dbo].[Students]
GO

CREATE TABLE [dbo].[Students] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [Number] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
  [Name] nvarchar(8) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [Sex] nvarchar(2) COLLATE Chinese_PRC_CI_AS NULL,
  [Age] int NOT NULL,
  [Phone] nvarchar(12) COLLATE Chinese_PRC_CI_AS NULL,
  [QQ] nvarchar(12) COLLATE Chinese_PRC_CI_AS NULL,
  [Wechat] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL,
  [Status] nvarchar(4) COLLATE Chinese_PRC_CI_AS NULL,
  [ClassesId] int NOT NULL,
  [PassWord] nvarchar(16) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[Students] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Students]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Students] ON
GO

INSERT INTO [dbo].[Students] ([Id], [Number], [Name], [Sex], [Age], [Phone], [QQ], [Wechat], [Status], [ClassesId], [PassWord]) VALUES (N'3', N'001', N'江崟才', N'男', N'20', N'11111111111', N'11111111111', N'11111111111', N'正常', N'2', N'123')
GO

INSERT INTO [dbo].[Students] ([Id], [Number], [Name], [Sex], [Age], [Phone], [QQ], [Wechat], [Status], [ClassesId], [PassWord]) VALUES (N'4', N'002', N'耿思瑶', N'女', N'20', N'11111111111', N'11111111111', N'11111111111', N'正常', N'3', N'123')
GO

INSERT INTO [dbo].[Students] ([Id], [Number], [Name], [Sex], [Age], [Phone], [QQ], [Wechat], [Status], [ClassesId], [PassWord]) VALUES (N'7', N'003', N'董权德', N'男', N'20', N'12345678978', N'12345678978', N'12345678978', N'挂籍', N'2', N'123')
GO

INSERT INTO [dbo].[Students] ([Id], [Number], [Name], [Sex], [Age], [Phone], [QQ], [Wechat], [Status], [ClassesId], [PassWord]) VALUES (N'8', N'004', N'张照坤', N'男', N'20', N'12345678998', N'12345678998', N'12345678998', N'退学', N'3', N'123')
GO

INSERT INTO [dbo].[Students] ([Id], [Number], [Name], [Sex], [Age], [Phone], [QQ], [Wechat], [Status], [ClassesId], [PassWord]) VALUES (N'9', N'005', N'金阳', N'女', N'20', N'32165498745', N'32165498745', N'95135789536', N'正常', N'4', N'123')
GO

INSERT INTO [dbo].[Students] ([Id], [Number], [Name], [Sex], [Age], [Phone], [QQ], [Wechat], [Status], [ClassesId], [PassWord]) VALUES (N'10', N'006', N'于适源', N'男', N'20', N'32165498745', N'35795165831', N'36951512354', N'正常', N'4', N'123')
GO

SET IDENTITY_INSERT [dbo].[Students] OFF
GO


-- ----------------------------
-- Table structure for Teachers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Teachers]') AND type IN ('U'))
	DROP TABLE [dbo].[Teachers]
GO

CREATE TABLE [dbo].[Teachers] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [UserName] nvarchar(15) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [PassWord] nvarchar(16) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [PowerId] int NOT NULL,
  [Name] nvarchar(8) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [Status] int NOT NULL,
  [Telephone] nvarchar(11) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL
)
GO

ALTER TABLE [dbo].[Teachers] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Teachers]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Teachers] ON
GO

INSERT INTO [dbo].[Teachers] ([Id], [UserName], [PassWord], [PowerId], [Name], [Status], [Telephone]) VALUES (N'1', N'liuliang', N'123456789', N'0', N'刘亮', N'1', N'12345678998')
GO

INSERT INTO [dbo].[Teachers] ([Id], [UserName], [PassWord], [PowerId], [Name], [Status], [Telephone]) VALUES (N'2', N'zhaodebing', N'123456789', N'1', N'赵德彬', N'1', N'12345678998')
GO

INSERT INTO [dbo].[Teachers] ([Id], [UserName], [PassWord], [PowerId], [Name], [Status], [Telephone]) VALUES (N'3', N'limingjie', N'123456789', N'0', N'李明杰', N'1', N'13888888888')
GO

SET IDENTITY_INSERT [dbo].[Teachers] OFF
GO


-- ----------------------------
-- Table structure for WeekArrangings
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[WeekArrangings]') AND type IN ('U'))
	DROP TABLE [dbo].[WeekArrangings]
GO

CREATE TABLE [dbo].[WeekArrangings] (
  [Id] int IDENTITY(1,1) NOT NULL,
  [Years] int NOT NULL,
  [Session] int NOT NULL,
  [StartWeek] int NOT NULL,
  [EndWeek] int NOT NULL
)
GO

ALTER TABLE [dbo].[WeekArrangings] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [WeekArrangings]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[WeekArrangings] ON
GO

INSERT INTO [dbo].[WeekArrangings] ([Id], [Years], [Session], [StartWeek], [EndWeek]) VALUES (N'1', N'2018', N'2', N'10', N'27')
GO

INSERT INTO [dbo].[WeekArrangings] ([Id], [Years], [Session], [StartWeek], [EndWeek]) VALUES (N'5', N'2018', N'1', N'37', N'54')
GO

SET IDENTITY_INSERT [dbo].[WeekArrangings] OFF
GO


-- ----------------------------
-- Primary Key structure for table __MigrationHistory
-- ----------------------------
ALTER TABLE [dbo].[__MigrationHistory] ADD CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY CLUSTERED ([MigrationId], [ContextKey])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table Classes
-- ----------------------------
CREATE NONCLUSTERED INDEX [IX_MajorsId]
ON [dbo].[Classes] (
  [MajorsId] ASC
)
GO

CREATE NONCLUSTERED INDEX [IX_TeacherId]
ON [dbo].[Classes] (
  [TeacherId] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table Classes
-- ----------------------------
ALTER TABLE [dbo].[Classes] ADD CONSTRAINT [PK_dbo.Classes] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table Classrooms
-- ----------------------------
ALTER TABLE [dbo].[Classrooms] ADD CONSTRAINT [PK_dbo.Classrooms] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table Courses
-- ----------------------------
CREATE NONCLUSTERED INDEX [IX_LecturerId]
ON [dbo].[Courses] (
  [LecturerId] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table Courses
-- ----------------------------
ALTER TABLE [dbo].[Courses] ADD CONSTRAINT [PK_dbo.Courses] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table CoursesArrangings
-- ----------------------------
CREATE NONCLUSTERED INDEX [IX_ClassesId]
ON [dbo].[CoursesArrangings] (
  [ClassesId] ASC
)
GO

CREATE NONCLUSTERED INDEX [IX_CoursesId]
ON [dbo].[CoursesArrangings] (
  [CoursesId] ASC
)
GO

CREATE NONCLUSTERED INDEX [IX_WeekArrangingId]
ON [dbo].[CoursesArrangings] (
  [WeekArrangingId] ASC
)
GO

CREATE NONCLUSTERED INDEX [IX_ClassroomId]
ON [dbo].[CoursesArrangings] (
  [ClassroomId] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table CoursesArrangings
-- ----------------------------
ALTER TABLE [dbo].[CoursesArrangings] ADD CONSTRAINT [PK_dbo.CoursesArrangings] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table Exams
-- ----------------------------
CREATE NONCLUSTERED INDEX [IX_CoursesArrangingId]
ON [dbo].[Exams] (
  [CoursesArrangingId] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table Exams
-- ----------------------------
ALTER TABLE [dbo].[Exams] ADD CONSTRAINT [PK_dbo.Exams] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table Lecturers
-- ----------------------------
ALTER TABLE [dbo].[Lecturers] ADD CONSTRAINT [PK_dbo.Lecturers] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table Majors
-- ----------------------------
ALTER TABLE [dbo].[Majors] ADD CONSTRAINT [PK_dbo.Majors] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table Rollcalls
-- ----------------------------
CREATE NONCLUSTERED INDEX [IX_CoursesArrangingId]
ON [dbo].[Rollcalls] (
  [CoursesArrangingId] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table Rollcalls
-- ----------------------------
ALTER TABLE [dbo].[Rollcalls] ADD CONSTRAINT [PK_dbo.Rollcalls] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table Students
-- ----------------------------
CREATE NONCLUSTERED INDEX [IX_ClassesId]
ON [dbo].[Students] (
  [ClassesId] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table Students
-- ----------------------------
ALTER TABLE [dbo].[Students] ADD CONSTRAINT [PK_dbo.Students] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table Teachers
-- ----------------------------
ALTER TABLE [dbo].[Teachers] ADD CONSTRAINT [PK_dbo.Teachers] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table WeekArrangings
-- ----------------------------
ALTER TABLE [dbo].[WeekArrangings] ADD CONSTRAINT [PK_dbo.WeekArrangings] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Foreign Keys structure for table Classes
-- ----------------------------
ALTER TABLE [dbo].[Classes] ADD CONSTRAINT [FK_dbo.Classes_dbo.Majors_MajorsId] FOREIGN KEY ([MajorsId]) REFERENCES [Majors] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[Classes] ADD CONSTRAINT [FK_dbo.Classes_dbo.Teachers_TeacherId] FOREIGN KEY ([TeacherId]) REFERENCES [Teachers] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table Courses
-- ----------------------------
ALTER TABLE [dbo].[Courses] ADD CONSTRAINT [FK_dbo.Courses_dbo.Lecturers_LecturerId] FOREIGN KEY ([LecturerId]) REFERENCES [Lecturers] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table CoursesArrangings
-- ----------------------------
ALTER TABLE [dbo].[CoursesArrangings] ADD CONSTRAINT [FK_dbo.CoursesArrangings_dbo.Classrooms_ClassroomId] FOREIGN KEY ([ClassroomId]) REFERENCES [Classrooms] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[CoursesArrangings] ADD CONSTRAINT [FK_dbo.CoursesArrangings_dbo.Courses_CoursesId] FOREIGN KEY ([CoursesId]) REFERENCES [Courses] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[CoursesArrangings] ADD CONSTRAINT [FK_dbo.CoursesArrangings_dbo.WeekArrangings_WeekArrangingId] FOREIGN KEY ([WeekArrangingId]) REFERENCES [WeekArrangings] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[CoursesArrangings] ADD CONSTRAINT [FK_dbo.CoursesArrangings_dbo.Classes_ClassesId] FOREIGN KEY ([ClassesId]) REFERENCES [Classes] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table Exams
-- ----------------------------
ALTER TABLE [dbo].[Exams] ADD CONSTRAINT [FK_dbo.Exams_dbo.CoursesArrangings_CoursesArrangingId] FOREIGN KEY ([CoursesArrangingId]) REFERENCES [CoursesArrangings] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table Rollcalls
-- ----------------------------
ALTER TABLE [dbo].[Rollcalls] ADD CONSTRAINT [FK_dbo.Rollcalls_dbo.CoursesArrangings_CoursesArrangingId] FOREIGN KEY ([CoursesArrangingId]) REFERENCES [CoursesArrangings] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table Students
-- ----------------------------
ALTER TABLE [dbo].[Students] ADD CONSTRAINT [FK_dbo.Students_dbo.Classes_ClassesId] FOREIGN KEY ([ClassesId]) REFERENCES [Classes] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO

